Release PV800 SV100

The theme for this release is new features to increase flexibility in Account Reconciliations and Transaction Matching.

Prerequisites

  • This solution is compatible with OneStream Platform v8.

  • The language code is changed from VB.Net to CSharp (C#). With this change, any business rule changes should be written in CSharp. If you want to make changes in VisualBasic, do so in a separate business rule. Business rule changes are not supported by OneStream and are therefore not encouraged.

  • Review the information in this section before you install, deploy, or upgrade. OneStream strongly recommends that you upgrade in a Development environment before upgrading in the Production application.

  • If you upgrade using Uninstall Full, custom templates are removed and replaced with default templates. If you created custom templates that you want to continue to use, save the Excel files outside of OneStream Financial Close and upload them after you upgrade. If you upgrade using Uninstall UI, custom templates are retained.

  • You must uninstall the UI for Account Reconciliations and Transaction Matching before installing this release.

  • If Account Reconciliations or Transaction Matching are currently installed, you must be on these versions to be able to install OneStream Financial Close:

    • Account Reconciliations PV440 SV200 or later

    • Transaction Matching PV530 SV201

Compatibility

Component

Description

OneStream 8.0.0 or later

Minimum OneStream Platform version required to install this version of OneStream Financial Close.

See the Upgrade Guide.
Microsoft SQL Server

One of these versions of Microsoft SQL Server is required:

  • Standard Edition 2016 SP1 or later

  • Enterprise Edition 2012 or later

Migration

If you have reconciliations that have a frequency other than monthly and migrate to OneStream Financial Close version PV710 SV201 or later, you may need to mark the reconciliations as required in the current period and then run discover for the current period. (MP1-4614, MP1-4688)

New

Account Reconciliations

Watch to learn what's new in Account Reconciliations (1:29).

  • You can copy any comments and pull forward your own comments from one period to the next while you are completing a step in the workflow. (MP1-2678)

  • A comment that was pulled forward cannot be edited. You can delete a comment that was pulled forward, but you cannot delete the original comment until you first delete each instance that was pulled forward. (MP1-4651)

  • You can edit and delete your own comments while you are completing a step in the workflow. (MP1-4526)

  • The Comments section includes a column that displays the booked period, which indicates the period the comment was created. This helps track comments that have been pulled forward and new comments. (MP1-4620)

  • Administrators can select which columns are visible for all users in the Account Reconciliations page and the Scorecard grids and set the order in which they display. (MP1-4516)

  • Administrators can create up to three custom attribute columns to display in the Account Reconciliations page for all users. They can be free-form text boxes or have a drop-down menu of values. (MP1-3369)

  • Administrators can edit the active custom attribute fields in the Edit Reconciliation Attributes and Edit Account Group dialog boxes. (MP1-4524)

  • Custom attribute fields with a drop-down menu of values include a blank value option. (MP1-4654)

  • Custom attribute fields are included in the Reconciliation Inventory Import and Export templates. (MP1-4522)

  • Custom attribute fields are not included as options in the Substitution Variable Selector drop-down menu. (MP1-4680)

  • The Audit Log includes a record of changes to all active attributes, including custom attributes. (MP1-4532)

Transaction Matching

Watch to learn what's new in Transaction Matching (1:41).

  • In Data Sets, administrators can select which fields are editable on the Transactions page directly in the grid for transactions that are not matched and not associated with a detail item in RCM. The following fields cannot be set as editable: SourceID, S.Cons, Cons, S.Scenario, Scenario, S.Time, Time, S.View, View, S.Origin, Origin, WF Profile, WF Time, and Status WF Time. (MP1-4658)

  • Fields for Matched transactions cannot be edited in the grid on the Transactions page. (MP1-4713)

  • A Notes column is included on the Transactions page that can be updated directly in the grid by typing in the field. (MP1-4652)

  • Update User and User Time (UTC) columns display on the Transactions page to track the last update made to any field for a transaction. (MP1-4652)

  • The Notes field is included in the Export file for each grid that includes the Notes column. (MP1-4695)

  • The Reason Code column on the Transactions page can be updated directly in the grid by clicking in the field to display a drop-down menu of options. You can only assign reason codes that are active. (MP1-4653)

  • On the Transactions page, you can select multiple transactions to edit multiple instances of notes, reason codes, or both at the same time for more efficient updates. (MP1-4690)

  • You can only enter valid values in the dimension fields. (MP1-4692)

Enhancements

Account Reconciliations

  • The Reconciliation ID column is included in the Reconciliation S-Items dialog box for account groups. (MP1-4590)

  • Child reconciliations containing T-Items or S-Items cannot be added to or removed from an account group. (MP1-4588)

Transaction Matching

None

Fixed Issues

Account Reconciliations

  • When you select multiple reconciliations and click Audit, an Audit report is created and populated with the relevant data. (MP1-4044)

  • If BalCheck causes a change in the Explained balance of an item, the State History will be updated to display that Balanced Changed action and details. (MP1-2620)

  • In Scorecard, the Top Unreconciled by Entity section displays the 10 reconciliations with the most unreconciled entities in descending order. In Analysis, the Past Due by Entity section displays the 10 reconciliations with the most entities past due in descending order. (MP1-4241)

  • If you delete an S-Doc from a completed reconciliation, it will not remove the S-Doc from previous periods. (MP1-4539)

  • When you upgrade, the status of the Multi-Currency Reconciliations option in the Global Setup page will remain unchanged. (MP1-4168)

  • In the RCM_SolutionHelper, TimeDimHelper calls were replaced with BRApi.Finance.Time calls to translate detail items on a weekly basis. (MP1-4052)

  • If you select a reconciliation item with the Access Group set to (Unassigned) and the Preparer and Approver assigned and you can click either Reports or Audit, a report is created that is populated with the relevant data. (MP1-4043)

  • In Reconciliation Exposure, the amounts displayed are accurate for all currency types and currency levels: account, local, and reporting. (MP1-4536)

  • If you add an S-Doc, it will display under Reconciliation Support for the period it was added as well as future periods. (MP1-4701)

  • In the single currency S-Doc template MultiPeriodTemplate.xlsx, when you enter an amount in the Amortization Detail section in column I, it will be calculated, and the Total Amortization and Unamortized Balance amounts will be updated in column I. (MP1-4609)

  • Commenters and Viewers cannot attach R-Docs to reconciliations. (MP1-4535)

  • You can run process at the parent workflow level. It will not cause an error. (MP1-4741)

  • When you discover and run process, the Explained amount for the reconciliation includes the S-Doc item amounts. (MP1-4744)

Transaction Matching

  • Navigating to the Data Splitting page will not cause an error. (MP1-4717)

  • In .NET Globalization > OneStreamApp if Culture is set to US, it will not cause an error when you log in and access the TXM dashboard. (MP1-4410)

Known Issues

Account Reconciliations

  • If upgrading from a previous version of OneStream Financial Close, after installing and launching the Account Reconciliations dashboard for the first time, you will likely receive the following error message: "Must specify valid information for parsing in the string." To resolve this issue, log out and back in to the solution.

  • Performing an Uninstall UI resets the Workspace Dashboard Name (Custom Workflow) in Account Rec Scenario > Workflow Settings to (Unassigned). An administrator must reassign this setting in the Workflow Profile. (MP1-700)

  • After migration, child reconciliations may not match the account group MC Enabled attribute. This can happen if the account group MC_Effective date was set after the child reconciliation's date. You can manually update the attribute if needed. (MP1-3393)

  • Upon initial implementation, make sure to select the correct period that you want to start in. For example, if you Discover in February 2022 and then change your mind and want to have data in January 2022, you cannot go back and Discover in January. You would first need to delete February as a workaround.

  • If you make any changes to currency for an individual reconciliation or account group (for example, changing from single currency to multi-currency or changing the currency type) with existing detail items, the detail items may not be valid. You will need to delete the detail items and manually re-create them. To avoid this issue, make any changes to currency before adding detail items.

  • After Process, if you delete a pulled forward R-Doc and run process again, the deleted R-Doc will be pulled forward again and display in the Reconciliation Workspace in the Detail Items grid in Reconciliation Support. (MP1-4697)

Transaction Matching

  • When attempting to install OneStream Financial Close version PV710 SV101 or later, if you receive an error on Upgrade Step 6 of the Setup Table script that prevents the solution from finishing installation, contact OneStream Support. (MP1-4568)

Contacting Support

Contact OneStream Support by registering at http://support.onestreamsoftware.com and then emailing support@onestreamsoftware.com.